IF NOT EXISTS (SELECT 1 FROM sys.columns 
			WHERE name = 'StatusDesc' 
			AND object_id = OBJECT_ID(N'[dbo].[CGO_GameEnrollmentStatus]'))
BEGIN
  ALTER TABLE dbo.CGO_GameEnrollmentStatus ADD StatusDesc NVARCHAR(100) NULL
END

UPDATE dbo.CGO_GameEnrollmentStatus
SET StatusDesc = StatusCode